Tabela ExtSystemInfo

Definicja tabeli ExtSystemInfo

Name

ExtSystemInfo

Code

ExtSystemInfo

Comment

 


Lista kolumn tabeli ExtSystemInfo

Name

Code

ExtSystemInfoID

ExtSystemInfoID

ExtOrgUnitInfoID

ExtOrgUnitInfoID

EpisodeID

EpisodeID

EventID

EventID

AccountDataID

AccountDataID

ExtAccountDataInfoID

ExtAccountDataInfoID

Ext_ExtOrgUnitInfoID

Ext_ExtOrgUnitInfoID


Kolumna ExtSystemInfoID tabeli ExtSystemInfo

Definicja kolumny ExtSystemInfoID tabeli ExtSystemInfo

Name

ExtSystemInfoID

Code

ExtSystemInfoID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExtOrgUnitInfoID tabeli ExtSystemInfo

Definicja kolumny ExtOrgUnitInfoID tabeli ExtSystemInfo

Name

ExtOrgUnitInfoID

Code

ExtOrgUnitInfoID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli ExtSystemInfo

Definicja kolumny EpisodeID tabeli ExtSystemInfo

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

No

Comment

 


Kolumna EventID tabeli ExtSystemInfo

Definicja kolumny EventID tabeli ExtSystemInfo

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna AccountDataID tabeli ExtSystemInfo

Definicja kolumny AccountDataID tabeli ExtSystemInfo

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtAccountDataInfoID tabeli ExtSystemInfo

Definicja kolumny ExtAccountDataInfoID tabeli ExtSystemInfo

Name

ExtAccountDataInfoID

Code

ExtAccountDataInfoID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Ext_ExtOrgUnitInfoID tabeli ExtSystemInfo

Definicja kolumny Ext_ExtOrgUnitInfoID tabeli ExtSystemInfo

Name

Ext_ExtOrgUnitInfoID

Code

Ext_ExtOrgUnitInfoID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ExtSystemInfo

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExtSystemInfo

Definicja klucza Identifier_1 tabeli ExtSystemInfo

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment